Ulabox is a Spainish start-up. The range of products is mainly focus on packaged foods,So it is easy to understand that supply chain is the key to compete with others, such as Amazon,… Ulabox has opened 3 warehouses: 2 in Barcelona and 1 Madrid. Fresh food like fish, vegetable and household items are core value of Ulabox to compete with giant Amazon. Nearly, It has coporated with other businesses. Widen products to have more energies and widen customers is a recent strategy of Ulabox.
If you want to know more, please to feel free with seaching this link Ulabox
I also did other ecommerce in notebook. It is a Olist ecommerce from Brazil, operating model is different from Ulabox.
| customer | order | total_items | discount. | weekday | hour | food | fresh | drinks | home | beauty | health | baby | pets |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 45 | 23.03 | 4 | 13 | 9.46 | 87.06 | 3.48 | 0.00 | 0.00 | 0.00 | 0.0 | 0 |
| 0 | 1 | 38 | 1.22 | 5 | 13 | 15.87 | 75.80 | 6.22 | 2.12 | 0.00 | 0.00 | 0.0 | 0 |
| 0 | 2 | 51 | 18.08 | 4 | 13 | 16.88 | 56.75 | 3.37 | 16.48 | 6.53 | 0.00 | 0.0 | 0 |
| 1 | 3 | 57 | 16.51 | 1 | 12 | 28.81 | 35.99 | 11.78 | 4.62 | 2.87 | 15.92 | 0.0 | 0 |
| 1 | 4 | 53 | 18.31 | 2 | 11 | 24.13 | 60.38 | 7.78 | 7.72 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 5 | 8 | 23.89 | 4 | 13 | 0.00 | 100.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 6 | 35 | 17.26 | 1 | 10 | 13.01 | 51.84 | 29.36 | 5.79 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 7 | 12 | 6.61 | 4 | 8 | 17.21 | 67.93 | 14.86 | 0.00 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 8 | 35 | 22.29 | 1 | 12 | 15.50 | 61.65 | 22.85 | 0.00 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 9 | 44 | 20.39 | 2 | 12 | 15.29 | 44.11 | 12.28 | 8.90 | 15.53 | 3.90 | 0.0 | 0 |
| 1 | 10 | 17 | 18.41 | 4 | 9 | 16.92 | 70.15 | 12.93 | 0.00 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 11 | 7 | 15.00 | 1 | 8 | 0.00 | 39.93 | 60.07 | 0.00 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 12 | 30 | 18.86 | 1 | 9 | 22.90 | 40.36 | 14.47 | 10.68 | 0.00 | 11.58 | 0.0 | 0 |
| 1 | 13 | 35 | 16.38 | 1 | 11 | 11.46 | 79.06 | 9.48 | 0.00 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 14 | 32 | 17.41 | 1 | 10 | 13.37 | 45.57 | 28.61 | 0.00 | 0.00 | 12.46 | 0.0 | 0 |
| 1 | 15 | 27 | 21.80 | 1 | 9 | 48.23 | 20.37 | 15.38 | 8.29 | 7.73 | 0.00 | 0.0 | 0 |
| 1 | 16 | 38 | 17.31 | 1 | 11 | 12.88 | 64.26 | 9.43 | 0.00 | 13.42 | 0.00 | 0.0 | 0 |
| 1 | 17 | 28 | 18.76 | 1 | 11 | 14.57 | 43.42 | 22.09 | 13.18 | 6.74 | 0.00 | 0.0 | 0 |
| 1 | 18 | 31 | 16.49 | 1 | 12 | 24.27 | 33.09 | 16.18 | 0.00 | 0.00 | 26.47 | 0.0 | 0 |
| 1 | 19 | 23 | 19.52 | 1 | 13 | 23.22 | 56.85 | 19.93 | 0.00 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 20 | 30 | 17.89 | 2 | 11 | 14.62 | 32.77 | 18.71 | 0.00 | 0.00 | 0.00 | 33.9 | 0 |
| 1 | 21 | 45 | 17.27 | 1 | 10 | 20.19 | 63.32 | 11.53 | 4.97 | 0.00 | 0.00 | 0.0 | 0 |
| 1 | 22 | 36 | 16.62 | 5 | 9 | 18.66 | 47.13 | 17.50 | 0.00 | 0.00 | 16.71 | 0.0 | 0 |
| 2 | 23 | 26 | 2.97 | 6 | 23 | 24.10 | 22.29 | 38.69 | 14.92 | 0.00 | 0.00 | 0.0 | 0 |
| 3 | 24 | 28 | 2.21 | 1 | 10 | 36.51 | 31.93 | 27.18 | 4.38 | 0.00 | 0.00 | 0.0 | 0 |
| 3 | 25 | 67 | 4.19 | 7 | 21 | 12.47 | 68.13 | 3.46 | 15.93 | 0.00 | 0.00 | 0.0 | 0 |
| 3 | 26 | 27 | 3.23 | 1 | 10 | 25.45 | 36.17 | 10.34 | 28.03 | 0.00 | 0.00 | 0.0 | 0 |
| 3 | 27 | 6 | 0.00 | 2 | 20 | 12.50 | 67.74 | 0.00 | 19.76 | 0.00 | 0.00 | 0.0 | 0 |
| 3 | 28 | 27 | 5.80 | 1 | 13 | 5.20 | 65.05 | 13.30 | 16.45 | 0.00 | 0.00 | 0.0 | 0 |
| 3 | 29 | 19 | 0.00 | 4 | 12 | 28.26 | 56.40 | 15.34 | 0.00 | 0.00 | 0.00 | 0.0 | 0 |
I will cover some aspects below: - 1. Time aspect - 2. Product aspect - 3. Order times, discount
Distribution of Hour and Weekday
Distribution of range of products
Boxplot